Oracle Insurance Rules Workbench Data Sources Details (Palette/Release management Services)

Pre-Requisites

Migrate scripts should be executed in the OIRW central schema , OIPA, and IVS schemas. For Release 12.2, migration scripts are provided with the media pack and the same should be executed on successful creation of the schema.

  • Copy the following script files from the Palette distribution ZIP/scripts directory as per the stack.

  • Copy the migration script from "palette-distribution\scripts\central\oracle" - Execute the migrate script "OIRW-12.1.0.0 migrate.sql, OIRW-12.2.0.0 migrate.sql" on the OIRW central schema.

  • Copy the migration script from "palette-distribution\scripts\oipa\oracle" - Execute the migration scripts "OIRW-12.1.0.0 migrate.sql", "OIRW-12.2.0.0 migrate.sql" on the OIPA schema (Note: OIPA/IVS changes will be taken care of by the upgrade utility).

  • Copy the migration script from "palette-distribution\scripts\ivs\oracle" - Execute the migrate script "OIRW-12.2.0.0 migrate.sql" on IVSSchema.

The config.yaml file for Palette and RM microservices is where the data source information is defined for an application to run. OIRW requires central schema data sources to be defined to authenticate and authorize.

Configuration of the data sources that are required for OIRW to run:

Palette/RM Central Schemas

# Properties for the central data source (Rules Workbench schema).
# For Oracle
javax.sql.DataSource.central.dataSourceClassName: oracle.jdbc.pool.OracleDataSource
javax.sql.DataSource.central.dataSource.url: jdbc:oracle:thin:@localhost:<port>:<sid>
javax.sql.DataSource.central.dataSource.user: <user>
javax.sql.DataSource.central.dataSource.password: <password>